AUTHORS: Wesin Alves, Aldebaro Klautau

Download as PDF

ABSTRACT: Supervisory control and data acquisition (SCADA) systems are critical for protection and safety operations in modern energy systems. A current challenge is understanding the system behavior through the large volume of data generated by SCADA in which it involves measurements of thousands of heterogeneous physical variables of power systems stored in various tables in a database. In this scenario, the Online Analysis Process (OLAP) in a Data Warehouse (DW) stands out as the most appropriate tool for understanding the electrical system behavior using such complex database. The main contribution of this article is the elaboration of a multidimensional modeling of a DW applied to a SCADA in order to better understanding behavior system and provide easy access to the information stored in its database. Pentaho Suite tools were used to develop proposed approach and experiments with real data from a Brazilian energy company were carried out to illustrate the proposed approach.

KEYWORDS: Data Warehouse, OLAP, massive datasets, multidimensional modeling, SCADA, electric power system

REFERENCES:

[1] Y. Zhang, L. Wang, Y. Xiang and C.-W. Ten, “Inclusion of SCADA Cyber Vulnerability in Power System Reliability Assessment Considering Optimal Resources Allocation,” IEEE Transactions on Power Systems, pp. 4379-4394, 2016.

[2] S. Goose, J. Kirsh and D. Wei, “Skyda: cloudbased, segure SCADA-as-a-service,” International Transactions on Eletrical Energy Systems, vol. 25, n. 1, pp. 3004-3016, 2015.

[3] J. C. Cepeda, G. Rivera and L. Farinango, “Improving the Computer Aided Power System Operation in Ecuador: Enhancements to SCADA/EMS,” in Asia-Pacifc Conference on Computer Aided System Engineering, 2015.

[4] M. Moreto and J. R. Rolim, “Using phasor data records and sequence of events to automate the classification of disturbances of power generating units,” Eletric Power Systems Research, vol. 81, n. 1, pp. 1266-1273, 2011.

[5] T. Wang, G. Zhang, J. Zhao, Z. He, J. Wang and M. J. Perez-Jimenez, “Fault Diagnosis of Electric Power Systems Based on Fuzzy Reasoning Spiking Neural P Systems,” IEEE Transactions on Power Systems , pp. 1182- 1194, 2015.

[6] E. A. Zamora-Cárdenas, C. R. Fuerte-Esquivel, A. Pizano-Martínez and H. J. Estrada-García, “Hybrid state estimator considering SCADA and synchronized phasor measurements in VSC-HVDC transmission links,” Eletric Power Systems Research, vol. 133, n. 1, pp. 42-50, 2015.

[7] I. Ohana, Experimentos de mineração de dados aplicados a sistemas SCADA de usinas hidrelétricas, Belém - Universidade Federal do Pará, 2012.

[8] D. Shi, Y. Lee, X. Duan and Q. H. Wu, “Power System Data Warehouses,” IEEE Computer Applications in Power, 2001.

[9] S. Wang, T. He and X. Ma, “PCA-based Preprocessing Method of Eletronic Data in Power Grid,” in International Conference on Computer, Mechatronics, Control and Eletronic Engineering (CMCEE), 2010.

[10] J. C. Ferreira, J. d. Almeida and A. R. Silva, “The Impact of Driving Styles on Fuel Consumption: A Data-Warehouse-and-DataMining-Based Discovery Process,” Intelligent Transportation Systems , pp. 2653 - 2662, 2015.

[11] E. B. Alhysat and M. Al-Dalahmeh, “Data warehouse sucess and strategic oriented business intelligence: a theoretical framework,” Journal of Management Research, pp. 169-184, 2013.

[12] W. H. Inmon and R. Hackathorn, Building the Data Warehouse: getting started, New York: Wiley, 2005.

[13] N. Jacome-Grajales, J. Escobedo-Briones, G. Arroyo-Figueroa and J. Roblero, “Application of Business Intelligence to the Power System Process Security,” in Third International Conference on Innovative Computing Technology (INTECH), 2013.

[14] P. Pico-Valencia, “Business intelligence applied to monitoring and meta-monitoring scenarios,” in 11th Iberian Conference on Information Systems and Technologies (CISTI), 2016.

[15] J. Gubalová, “The use of Business Intelligence Tools for leadership and university administration,” in 13th International Conference on Emerging eLearning Technologies and Applications (ICETA), 2015.

[16] F. Bonchi, F. Giannotti, C. Gozzi, G. Manco, M. Nanni, D. Pedreshi, C. Renso and S. Ruggieri, “Web log data warehousing and mining for intelligent web caching,” Data and Knowledge Engineering, pp. 165-189, 2001.

[17] A. Kingdon, M. L. Nayembil, A. E. Richardson and A. G. Smith, “A geodata warehouse: Using denormalisation techniques as a tool for delivering spatially enabled integrated geological information to geologists,” Computer and Geosciences, pp. 87-97, 2016.

[18] E. Reolofs, L. Persoon, S. Nijesten, W. Wiessler, A. Dekker and P. Lambin, “Benefits of a clinical data warehouse with data mining tools to collect data for a radiotherapy trial,” Radiotherapy and Oncology, pp. 174-179, 2013.

[19] D. J. Berndt, J. W. Fisher, J. G. Craighead, A. R. Hevner, S. Luther and J. Studnick, “The role of data warehousing in bioterrorism surveillance,” Decision Support Systems, pp. 1383-1403, 2007.

[20] P. L. Takecian, M. K. Oikawa, K. R. Braghetto, P. Rocha, F. Lucena, K. Kavounis, K. S. Schlumpf, S. Acker, A. B. F. Carneiro-Proietti, E. C. Sabino, B. Custer, M. P. Busch and J. E. Ferreira, “Methodological guidelines for reducing the complexity of data warehouse development for transactional blood bank systems,” Decision Support Systems, pp. 728- 739, 2013.

[21] J. Lukic, M. Radenkovic, Despotovic-Zrakic and A. Labus, “A hybrid approach to building a multi-dimensional business inteligence system for electricity grid operators,” Utilities Policy, pp. 1-12, 2016.

[22] C. Pentaho, 13 nov 2016.

[Online]. Available: http://community.pentaho.com/.

[23] C. Queiroz, A. Mahmood and Z. Tari, “An analytical framework for evaluating survivability of SCADA systems,” in 10th IEEE International Conference on Computer and Information Technology, 2010.

[24] T. Sanislav, D. Capatina and L. Miclea, “A data mining experiment on a SCADA system’s historical acquired data,” IEEE International Conference on Automation, Quality and Testing, Robotics, pp. 419-422, 2008.

[25] S. Luján-Mora, J. Trujillo and I.-Y. Song, “A UML profile for multidimensional modelling in data warehouses,” Data & Knowledge Engineering, pp. 725-769, 2006.

[26] D. J. Berndt, A. R. Hevner and J. Studnicki, “The Catch data warehouse: support for community health care decision-making,” Decision Support Systems, vol. 35, p. 367– 384, 2003.

[27] A. Marinheiro and J. Bernardino, “Experimental Evaluation of Open Source Business Intelligence Suites using OpenBRR,” IEEE Latin America Transactions, vol. 13, n. 3, pp. 810-817, 2015.

[28] S. Cepel, “Sistema Aberto de Gerenciamento de Energia,” Cepel, 2017.

[Online]. Available: http://www.sage.cepel.br/sage/index.php/pt/.

[Accessed in 09 02 2017].

[29] G. N. Korres, “An integer-arithmetic algorithm for observality analysis of systems with SCADA and PMU measurements,” Electric Power System Research, pp. 1388-1402, 2011.

[30] G. N. Korres and N. M. Manousakis, “State estimation and bad data processing for systema inclugind PMU and SCADA measruements,” Electric Power System Research, pp. 1514- 1524, 2011.

[31] R. Batra and V. K. Chandna, “Comparative analysis for preprocessing voltage at remote terminal unit by using different menbership functions,” in IEEE International Advvance Computing Conference (IACC), Patiala, India, 2009.

[32] E. M. Davidson, S. D. J. McArthur, J. R. McDonald, T. Cumming and I. Watt, “Applying Multi-Agent Systems Technology in Pratice: Automated Management and Analysis of SCADA and Digital Fault Recorder Data,” IEEE Transactions On Power Systems, vol. 21, n. 2, pp. 559-567, 2006.

[33] R. Gupta, Moinuddin and P. Kumar, “Cloud computing data mining to SCADA for energy management,” in Annual IEEE India Conforence (INDICON), 2015.